class Projects < ActiveRecord::Migration
  def self.up
    query = <<-_SQL
      CREATE TABLE `projects` (
        `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `name` VARCHAR( 255 ) NOT NULL ,
        UNIQUE (
          `name`
        )
      ) ENGINE = MYISAM ;
    _SQL
    
    execute query
  end

  def self.down
    execute "DROP TABLE `projects` "
  end
end

